import openpyxl as vb

path = '../文件/读取数据.xlsx'
wb = vb.load_workbook(path)
wt = wb["Sheet1"]
"""
获取一个区域内的数据
"""
cellArea = wt["A1:C10"]
for cellRow in cellArea:
    for cell in cellRow:
        print(cell.value)

"""
使用List
"""
print(list(wt.values))

"""
使用iter_rows或者iter_column
"""
for row in wt.iter_rows(min_row=1, max_row=10, min_col=1, max_col=3):
    for cell in row:
        print(cell.value)
